﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace TeamBuy.AccessWebUI
{
    public partial class Deals : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            adsAllDeals.SelectCommand = "SELECT [DealID], [CityID], [DealTitle], [RealPrice], [NowPrice], [DateStarted], [DateEnded], [DealNumber], [SuccessNumber], [PayNumber], [MainImage], [ProductName], [DealStatus], [IsCurrentDeal], [IsTodayMainDeal] FROM [S_Deal] WHERE ([CityID] = " + ((Components.Head)(Master.Master.FindControl("Head1"))).CurrentCityID + ") AND DateStarted<=#" + DateTime.Now.ToString() + "# ORDER BY DateStarted DESC";
        }
    }
}